In [90]:
import quandl
import pandas as pd
import matplotlib.pyplot as plt
pd.set_option('display.max_columns', None)  # or 1000
pd.set_option('display.max_rows', None)
In [84]:
quandl.ApiConfig.api_key='h6ozooCMxqLXz_Ch54Fs'
In [85]:
# data = quandl.get(["NSE/YESBANK"], start_date="2010-02-18", end_date="2020-02-18")
# data
In [91]:
df=pd.read_csv('A_EQUITY_ACTIVE.CSV')
df
Out[91]:
Unnamed: 0 Security Code Security Id Security Name dayHigh dayLow 52weekHigh 52weekLow
0 291 532532 JPASSOCIAT JAIPRAKASH ASSOCIATES LTD. 1.77 1.47 7.15 1.47
1 350 532939 RPOWER RELIANCE POWER LTD. 1.77 1.68 13.25 1.46
2 305 532667 SUZLON SUZLON ENERGY LTD. 2.33 2.22 8.40 1.80
3 329 532822 IDEA Vodafone Idea Ltd 3.28 2.83 21.32 2.61
4 194 521064 TRIDENT TRIDENT LTD. 5.70 5.55 8.45 5.22
5 24 500106 IFCI IFCI LTD. 6.05 5.78 14.58 5.62
6 48 500219 JISLJALEQS JAIN IRRIGATION SYSTEMS LTD. 6.60 6.32 64.65 6.32
7 27 500111 RELCAPITAL RELIANCE CAPITAL LTD. 7.14 6.75 214.30 6.71
8 209 523756 SREINFRA SREI INFRASTRUCTURE FINANCE LTD. 8.33 8.05 33.80 7.17
9 252 532218 SOUTHBANK SOUTH INDIAN BANK LTD. 9.87 9.62 18.55 8.50
10 266 532388 IOB INDIAN OVERSEAS BANK 10.00 9.03 15.80 8.75
11 165 511072 DHFL DEWAN HOUSING FINANCE CORPORATION LTD. 10.34 9.87 176.40 9.41
12 333 532839 DISHTV DISH TV INDIA LTD. 11.32 10.74 42.35 10.35
13 284 532505 UCOBANK UCO BANK 13.90 13.50 22.20 11.00
14 276 532480 ALBK ALLAHABAD BANK 14.60 13.75 58.80 13.75
15 268 532418 ANDHRABANK ANDHRA BANK 15.25 14.50 33.30 14.50
16 341 532885 CENTRALBK CENTRAL BANK OF INDIA 16.75 16.30 36.95 15.55
17 44 500183 HFCL HFCL Ltd 17.15 16.70 25.30 16.20
18 386 534690 LAKSHVILAS LAKSHMI VILAS BANK LTD. 17.40 17.15 97.35 13.35
19 388 534809 PCJEWELLER PC JEWELLER LTD. 17.80 17.00 167.60 16.80
20 178 513377 MMTC MMTC LTD. 19.50 18.80 29.90 14.00
21 249 532209 J&KBANK JAMMU & KASHMIR BANK LTD. 19.65 17.50 65.95 17.05
22 130 501150 CENTRUM CENTRUM CAPITAL LTD. 20.10 18.70 36.25 17.90
23 246 532179 CORPBANK CORPORATION BANK 21.20 20.30 32.15 13.60
24 378 533400 FCONSUMER Future Consumer Ltd 21.50 21.10 51.70 20.95
25 360 533098 NHPC NHPC LTD. 22.15 21.10 29.00 20.85
26 80 500390 RELINFRA RELIANCE INFRASTRUCTURE LTD. 22.25 20.90 146.25 18.00
27 255 532276 SYNDIBANK SYNDICATE BANK 22.35 21.20 46.60 21.20
28 366 533162 HATHWAY Hathway Cable & Datacom Ltd 23.10 21.75 38.60 17.55
29 316 532754 GMRINFRA GMR INFRASTRUCTURE LTD. 23.10 22.00 25.00 14.05
30 368 533206 SJVN SJVN Ltd 25.65 24.75 27.75 22.25
31 323 532800 TV18BRDCST TV18 BROADCAST LTD. 30.10 27.35 39.30 18.05
32 385 534309 NBCC NBCC (India) Ltd 30.55 28.50 68.35 28.50
33 436 540530 HUDCO Housing and Urban Development Corporation Ltd 33.90 32.55 47.70 28.70
34 304 532659 IDFC IDFC LIMITED 34.25 33.45 48.05 30.80
35 31 500116 IDBI IDBI BANK LTD. 34.70 33.25 48.10 23.55
36 22 500103 BHEL BHARAT HEAVY ELECTRICALS LTD. 34.90 33.40 78.75 33.40
37 180 513599 HINDCOPPER HINDUSTAN COPPER LTD. 35.80 34.65 52.70 27.90
38 302 532648 YESBANK YES BANK LTD. 37.55 33.70 285.90 29.05
39 399 539083 INOXWIND Inox Wind Ltd 38.00 37.00 80.75 30.80
40 21 500101 ARVIND ARVIND LTD. 38.75 38.05 96.50 33.30
41 404 539437 IDFCFIRSTB IDFC First Bank Ltd 38.80 37.80 56.90 36.15
42 254 532234 NATIONALUM NATIONAL ALUMINIUM CO.LTD. 39.20 38.20 59.50 36.90
43 25 500109 MRPL MANGALORE REFINERY & PETROCHEMICALS LTD. 41.35 39.65 76.10 39.65
44 193 520051 JAMNAAUTO JAMNA AUTO INDUSTRIES LTD. 41.90 39.05 65.35 30.40
45 29 500113 SAIL STEEL AUTHORITY OF INDIA LTD. 42.65 40.75 60.10 29.50
46 64 500294 NCC NCC Limited 42.70 37.70 119.15 37.70
47 69 500315 ORIENTBANK ORIENTAL BANK OF COMMERCE 43.50 40.35 119.00 40.35
48 213 524230 RCF RASHTRIYA CHEMICALS & FERTILIZERS LTD. 43.75 41.05 67.25 36.25
49 325 532809 FSL FIRSTSOURCE SOLUTIONS LTD. 45.50 42.85 57.85 36.55
50 183 514162 WELSPUNIND WELSPUN INDIA LTD. 45.70 43.45 66.05 41.00
51 169 511431 VAKRANGEE Vakrangee Limited-$ 46.50 44.20 70.95 22.75
52 274 532477 UNIONBANK UNION BANK OF INDIA 46.80 40.20 100.30 40.20
53 210 524000 MAGMA MAGMA FINCORP LTD. 50.75 49.85 138.20 37.00
54 289 532524 PTC PTC INDIA LTD. 51.35 50.10 84.55 50.10
55 45 500184 HSCL Himadri Speciality Chemical Ltd 52.05 49.80 126.50 49.80
56 81 500400 TATAPOWER TATA POWER CO.LTD. 52.25 50.55 76.90 50.40
57 272 532461 PNB PUNJAB NATIONAL BANK 52.45 49.90 99.90 49.90
58 336 532856 TIMETECHNO TIME TECHNOPLAST LTD. 52.75 49.25 108.60 42.40
59 181 513683 NLCINDIA NLC India Ltd 53.55 50.55 80.35 49.15
60 206 523598 SCI SHIPPING CORPORATION OF INDIA LTD. 56.90 52.80 69.80 24.85
61 359 533096 ADANIPOWER ADANI POWER LTD. 57.10 55.30 73.75 36.55
62 413 539807 INFIBEAM Infibeam Avenues Ltd 57.50 55.40 61.25 32.90
63 161 509496 ITDCEM ITD CEMENTATION INDIA LTD. 58.60 54.90 143.40 35.00
64 337 532865 MEGH MEGHMANI ORGANICS LTD. 58.90 54.50 73.00 40.60
65 247 532181 GMDCLTD GUJARAT MINERAL DEVELOPMENT CORPORATION LTD. 59.00 55.50 94.25 54.40
66 459 541233 LEMONTREE Lemon Tree Hotels Ltd 59.50 57.65 90.90 48.00
67 241 532149 BANKINDIA BANK OF INDIA 60.70 58.35 108.15 57.45
68 74 500338 PRSMJOHNSN Prism Johnson Ltd 64.95 63.20 104.00 58.65
69 223 530007 JKTYRE JK TYRE & INDUSTRIES LTD. 67.50 65.30 99.70 53.55
70 362 533148 JSWENERGY JSW Energy Ltd 68.40 64.05 80.00 57.75
71 469 570001 TATAMTRDVR Tata Motors Ltd - DVR 68.90 64.60 116.35 48.30
72 234 531508 EVEREADY EVEREADY INDUSTRIES INDIA LTD. 69.35 66.00 218.80 34.40
73 438 540595 TEJASNET Tejas Networks Ltd 70.00 66.70 206.20 64.70
74 309 532705 JAGRAN* JAGRAN PRAKASHAN LTD. 70.30 68.20 128.00 46.30
75 176 513023 NBVENTURES NAVA BHARAT VENTURES LTD. 71.50 67.55 121.00 58.50
76 222 530005 INDIACEM INDIA CEMENTS LTD. 73.00 69.55 116.90 67.90
77 113 500690 GSFC GUJARAT STATE FERTILIZERS & CHEMICALS LTD. 73.50 68.00 110.70 65.95
78 411 539597 JSLHISAR Jindal Stainless (Hisar) Ltd 75.90 72.70 101.25 58.00
79 303 532652 KTKBANK KARNATAKA BANK LTD. 77.20 75.05 141.15 68.00
80 370 533248 GPPL GUJARAT PIPAVAV PORT LTD. 79.90 77.85 103.65 74.00
81 393 535754 ORIENTCEM Orient Cement Ltd 80.50 78.75 125.00 64.45
82 93 500477 ASHOKLEY ASHOK LEYLAND LTD. 81.55 79.20 97.70 56.95
83 327 532814 INDIANB INDIAN BANK 82.00 78.00 292.35 78.00
84 239 532134 BANKBARODA BANK OF BARODA 82.30 78.15 143.60 78.15
85 207 523610 ITI ITI LTD. 82.50 80.05 107.45 56.15
86 3 500020 BOMDYEING BOMBAY DYEING & MFG.CO.LTD. 82.80 78.80 149.40 60.75
87 245 532178 ENGINERSIN ENGINEERS INDIA LTD. 83.45 78.40 128.60 78.40
88 13 500049 BEL BHARAT ELECTRONICS LTD. 83.80 79.50 122.15 74.85
89 90 500469 FEDERALBNK FEDERAL BANK LTD. 84.60 81.00 110.35 78.40
90 421 539981 MAXINDIA Max India Ltd 85.50 83.05 93.80 54.10
91 437 540575 STARCEMENT Star Cement Ltd 85.90 85.00 137.60 82.50
92 61 500285 SPICEJET SPICEJET LTD. 86.50 82.60 156.90 72.50
93 332 532832 IBREALEST INDIABULLS REAL ESTATE LTD. 88.00 83.10 151.00 38.00
94 116 500730 NOCIL NOCIL LTD. 88.35 84.90 150.40 73.90
95 443 540691 ABCAPITAL Aditya Birla Capital Ltd 89.00 85.15 115.30 75.60
96 347 532922 EDELWEISS Edelweiss Financial Services Ltd. 89.80 85.00 210.30 67.10
97 382 533655 TRITURBINE TRIVENI TURBINE LTD. 92.00 90.00 122.50 80.90
98 77 500378 JINDALSAW JINDAL SAW LTD. 93.15 87.45 102.70 63.10
99 267 532400 BSOFT Birlasoft Ltd 94.50 90.90 117.70 57.40
100 444 540701 DCAL* Dishman Carbogen Amcis Ltd 95.65 87.20 258.15 63.80
101 107 500645 DEEPAKFERT DEEPAK FERTILISERS & PETROCHEMICALS CORPORATIO... 97.35 94.25 169.00 76.45
102 173 512237 JAICORPLTD JAI CORP LTD. 98.20 92.65 132.65 65.55
103 311 532710 SADBHAV SADBHAV ENGINEERING LTD. 98.90 87.00 274.40 87.00
104 372 533271 ASHOKA ASHOKA BUILDCON LTD. 99.90 94.95 155.00 89.50
105 343 532890 TAKE TAKE SOLUTIONS LTD. 100.00 97.20 159.30 90.10
106 68 500312 ONGC OIL AND NATURAL GAS CORPORATION LTD. 100.30 96.60 178.95 96.60
107 380 533520 IBULISL Indiabulls Integrated Services Ltd 100.75 97.90 376.00 52.60
108 219 526371 NMDC NMDC LTD. 100.85 97.00 139.50 74.80
109 352 532947 IRB IRB INFRASTRUCTURE DEVELOPERS LTD. 101.25 94.50 159.80 56.10
110 182 514043 HIMATSEIDE HIMATSINGKA SEIDE LTD. 101.35 97.70 241.00 97.50
111 418 539889 PARAGMILK Parag Milk Foods Ltd 103.45 98.10 276.05 88.00
112 75 500339 RAIN Rain Industries Ltd 104.50 99.05 148.00 77.05
113 414 539844 EQUITAS Equitas Holdings Ltd 107.30 104.60 143.55 82.60
114 297 532555 NTPC NTPC LTD. 110.70 103.90 145.85 103.90
115 204 523405 JMFINANCIL JM FINANCIAL LTD.-$ 111.55 103.00 126.00 61.45
116 265 532374 STRTECH STERLITE TECHNOLOGIES LTD. 113.00 108.20 279.25 96.65
117 227 530965 IOC INDIAN OIL CORPORATION LTD. 115.10 110.45 170.40 107.55
118 406 539450 SHK S H Kelkar and Company Ltd 115.90 109.30 168.90 101.00
119 324 532805 REDINGTON REDINGTON (INDIA) LTD. 119.00 112.10 139.85 78.60
120 242 532155 GAIL GAIL (INDIA) LTD. 119.75 116.95 183.20 110.55
121 170 511676 GICHSGFIN GIC HOUSING FINANCE LTD. 120.20 116.30 281.90 116.30
122 26 500110 CHENNPETRO CHENNAI PETROLEUM CORPORATION LTD. 122.00 112.15 278.40 106.00
123 379 533519 L&TFH L&T FINANCE HOLDINGS LTD. 123.70 119.95 155.85 78.60
124 186 517334 MOTHERSUMI MOTHERSON SUMI SYSTEMS LTD. 124.35 116.60 175.50 91.15
125 364 533151 DBCORP D B Corp Ltd 125.35 124.00 208.90 123.10
126 151 506590 PHILIPCARB PHILLIPS CARBON BLACK LTD. 126.75 122.35 184.65 106.45
127 298 532622 GDL GATEWAY DISTRIPARKS LTD. 127.80 123.40 154.10 81.15
128 137 503310 SWANENERGY SWAN ENERGY LTD. 127.85 122.15 154.55 94.75
129 326 532810 PFC POWER FINANCE CORPORATION LTD. 128.30 123.20 138.80 90.50
130 348 532926 JYOTHYLAB Jyothy Labs Ltd 131.45 127.50 199.85 125.25
131 453 540769 NIACL The New India Assurance Company Ltd 132.10 127.80 224.00 94.15
132 124 500850 INDHOTEL INDIAN HOTELS CO.LTD. 132.50 126.85 164.10 121.15
133 361 533106 OIL OIL INDIA LTD. 133.35 127.00 188.60 118.50
134 123 500840 EIHOTEL EIH LTD. 137.60 133.30 214.95 130.80
135 354 532955 RECLTD REC Ltd 138.95 134.20 169.55 118.65
136 398 538835 INTELLECT Intellect Design Arena Ltd 140.90 134.40 292.00 133.00
137 376 533286 MOIL MOIL LTD. 141.10 137.15 171.85 118.20
138 147 506197 BLISSGVS BLISS GVS PHARMA LTD. 141.95 139.50 183.65 73.90
139 65 500295 VEDL Vedanta Limited 142.40 137.55 195.00 125.70
140 139 504067 ZENSARTECH ZENSAR TECHNOLOGIES LTD. 144.95 138.05 271.30 138.05
141 197 522275 GET&D GE T&D India Ltd 145.40 139.55 308.00 124.00
142 133 501455 GREAVESCOT GREAVES COTTON LTD. 145.60 137.80 157.25 112.60
143 296 532548 CENTURYPLY CENTURY PLYBOARDS (I) LTD.-$ 153.50 150.00 222.35 112.30
144 127 500877 APOLLOTYRE APOLLO TYRES LTD. 154.50 150.50 235.70 144.05
145 334 532843 FORTIS FORTIS HEALTHCARE LTD. 155.40 149.65 169.00 111.60
146 335 532848 DELTACORP DELTA CORP LTD. 155.70 146.65 277.75 116.05
147 125 500870 CASTROLIND CASTROL INDIA LTD. 157.90 150.40 172.80 112.75
148 423 540025 ADVENZYMES Advanced Enzyme Technologies Ltd 160.80 157.30 225.00 142.00
149 16 500085 CHAMBLFERT CHAMBAL FERTILISERS & CHEMICALS LTD. 161.60 151.80 196.25 133.70
150 318 532756 MAHINDCIE Mahindra CIE Automotive Limited 164.70 150.25 255.00 135.55
151 339 532872 SPARC SUN PHARMA ADVANCED RESEARCH COMPANY LTD. 166.45 160.55 210.70 107.00
152 340 532880 OMAXE OMAXE LTD. 167.00 154.65 217.65 143.95
153 468 542066 ADANIGAS Adani Gas Ltd 167.30 163.40 185.60 94.25
154 104 500570 TATAMOTORS TATA MOTORS LTD. 168.40 158.60 239.30 106.00
155 232 531426 TNPL TAMIL NADU NEWSPRINT & PAPERS LTD. 169.25 165.00 244.00 151.30
156 8 500038 BALRAMCHIN BALRAMPUR CHINI MILLS LTD. 170.95 161.35 195.00 109.65
157 229 531213 MANAPPURAM MANAPPURAM FINANCE LTD. 171.35 166.75 194.60 103.30
158 455 540975 ASTERDM Aster DM Healthcare Ltd 172.30 165.45 180.50 109.70
159 319 532772 DCBBANK DCB Bank Limited 173.00 166.60 244.60 164.95
160 375 533278 COALINDIA COAL INDIA LTD. 174.00 165.00 270.90 165.00
161 278 532483 CANBK CANARA BANK 174.80 167.65 302.00 167.65
162 41 500171 GHCL* GHCL LTD. 175.15 170.50 277.20 170.50
163 109 500670 GNFC GUJARAT NARMADA VALLEY FERTILIZERS & CHEMICALS... 176.10 171.00 337.65 155.15
164 17 500086 EXIDEIND EXIDE INDUSTRIES LTD. 178.05 173.90 234.40 166.00
165 277 532482 GRANULES GRANULES INDIA LTD.-$ 180.50 172.60 180.50 84.25
166 345 532898 POWERGRID POWER GRID CORPORATION OF INDIA LTD. 185.90 181.00 216.20 177.05
167 35 500135 ESSELPRO ESSEL PROPACK LTD. 187.15 177.75 197.00 78.85
168 46 500188 HINDZINC HINDUSTAN ZINC LTD. 189.10 184.65 291.80 184.65
169 257 532286 JINDALSTEL JINDAL STEEL & POWER LTD. 189.15 181.85 202.40 91.10
170 88 500440 HINDALCO HINDALCO INDUSTRIES LTD. 189.85 181.90 221.20 171.25
171 448 540750 IEX Indian Energy Exchange Ltd 195.00 181.30 199.95 112.00
172 285 532509 SUPRAJIT SUPRAJIT ENGINEERING LTD.-$ 196.75 187.00 246.75 146.00
173 369 533229 BAJAJCON Bajaj Consumer Care Ltd 197.45 189.00 367.00 188.75
174 462 541450 ADANIGREEN Adani Green Energy Ltd 200.05 188.55 243.25 30.05
175 299 532636 IIFL IIFL Finance Ltd 201.20 185.00 212.80 98.85
176 63 500292 HEIDELBERG HEIDELBERGCEMENT INDIA LTD. 201.65 195.05 217.60 146.00
177 87 500425 AMBUJACEM AMBUJA CEMENTS LTD. 203.30 197.80 244.00 184.15
178 353 532953 VGUARD V-GUARD INDUSTRIES LTD. 204.30 199.40 259.70 184.00
179 126 500875 ITC ITC LTD. 204.95 200.30 310.00 200.30
180 400 539150 PNCINFRA PNC Infratech Ltd 208.65 194.60 219.40 126.00
181 240 532144 WELCORP Welspun Corp Limited 209.30 200.20 233.70 89.30
182 371 533269 WABAG VA TECH WABAG LTD. 209.45 200.05 360.60 160.20
183 33 500125 EIDPARRY E.I.D.-PARRY (INDIA) LTD. 210.90 197.80 245.35 135.40
184 449 540755 GICRE General Insurance Corporation of India 212.05 205.65 333.85 154.00
185 338 532868 DLF DLF LTD. 219.25 216.60 266.65 133.90
186 250 532210 CUB CITY UNION BANK LTD. 222.00 219.80 249.00 172.00
187 37 500148 UFLEX UFLEX LTD. 223.00 217.00 276.25 181.00
188 358 533088 MHRIL MAHINDRA HOLIDAYS & RESORTS INDIA LTD. 225.05 223.25 256.00 185.10
189 195 522074 ELGIEQUIP ELGI EQUIPMENTS LTD. 227.80 224.65 309.60 220.50
190 23 500104 HINDPETRO HINDUSTAN PETROLEUM CORPORATION LTD. 230.40 222.50 333.45 211.35
191 76 500355 RALLIS RALLIS INDIA LTD. 231.30 225.50 246.80 139.10
192 389 534816 INFRATEL BHARTI INFRATEL LTD. 236.10 200.70 333.35 175.35
193 308 532702 GSPL GUJARAT STATE PETRONET LTD. 243.65 228.75 263.45 149.15
194 155 507685 WIPRO WIPRO LTD. 244.80 241.20 301.55 232.35
195 236 531599 FDC FDC LTD. 245.05 237.75 265.00 148.20
196 144 505537 ZEEL ZEE ENTERTAINMENT ENTERPRISES LTD. 247.10 238.65 489.75 203.70
197 192 519600 CCL CCL PRODUCTS (INDIA) LTD. 247.70 234.30 306.40 180.55
198 175 512599 ADANIENT ADANI ENTERPRISES LTD. 251.85 245.40 258.50 113.00
199 184 515030 ASAHIINDIA ASAHI INDIA GLASS LTD. 254.00 239.35 282.75 170.00
200 0 500003 AEGISLOG AEGIS LOGISTICS LTD. 257.70 246.95 257.70 160.05
201 287 532522 PETRONET PETRONET LNG LTD. 260.80 254.85 302.00 211.60
202 160 509488 GRAPHITE GRAPHITE INDIA LTD. 266.90 260.05 482.40 255.00
203 460 541301 ORIENTELEC Orient Electric Ltd 268.65 257.55 275.00 126.10
204 262 532321 CADILAHC CADILA HEALTHCARE LTD. 269.00 261.30 352.30 206.45
205 394 535755 ABFRL Aditya Birla Fashion and Retail Ltd 270.50 259.55 281.15 180.10
206 106 500620 GESHIP GREAT EASTERN SHIPPING CO.LTD. 276.05 269.00 369.35 212.20
207 228 531162 EMAMILTD EMAMI LTD.-$ 284.45 266.50 417.70 246.00
208 461 541336 INDOSTAR Indostar Capital Finance Ltd 286.00 281.75 442.85 166.00
209 351 532942 KNRCON KNR CONSTRUCTIONS LTD. 286.35 266.00 311.05 187.00
210 49 500228 JSWSTEEL JSW STEEL LTD. 289.05 281.10 313.40 201.90
211 403 539336 GUJGAS Gujarat Gas Ltd 290.00 277.20 313.45 116.00
212 417 539876 CROMPTON Crompton Greaves Consumer Electricals Ltd 299.00 281.70 301.45 192.00
213 237 531642 MARICO MARICO LTD. 300.70 292.00 403.70 292.00
214 391 535322 REPCOHOME REPCO HOME FINANCE LTD. 302.60 288.75 481.40 269.00
215 288 532523 BIOCON BIOCON LTD. 304.05 295.10 320.48 211.30
216 402 539268 SYNGENE Syngene International Ltd 307.55 304.65 368.10 280.00
217 426 540065 RBLBANK RBL Bank Ltd 308.05 292.25 716.55 230.55
218 226 530813 KRBL KRBL LTD. 308.25 297.00 391.20 186.80
219 395 535789 IBULHSGFIN Indiabulls Housing Finance Ltd 308.70 293.45 919.00 165.95
220 258 532296 GLENMARK GLENMARK PHARMACEUTICALS LTD. 313.40 303.60 667.00 267.30
221 401 539254 ADANITRANS Adani Transmission Ltd 314.65 297.00 365.80 192.00
222 28 500112 SBIN STATE BANK OF INDIA 319.00 309.50 373.70 244.35
223 463 541556 RITES RITES Ltd 319.50 300.40 331.00 160.48
224 321 532779 TORNTPOWER TORRENT POWER LTD. 321.35 306.25 332.50 230.45
225 78 500380 JKLAKSHMI JK LAKSHMI CEMENT LTD. 330.00 323.00 396.20 260.20
226 168 511243 CHOLAFIN Cholamandalam Investment and Finance Company Ltd 332.25 322.25 348.85 226.35
227 312 532714 KEC KEC INTERNATIONAL LTD. 338.80 330.25 358.30 230.35
228 253 532221 SONATSOFTW SONATA SOFTWARE LTD. 339.00 333.60 363.45 282.50
229 177 513375 CARBORUNIV CARBORUNDUM UNIVERSAL LTD. 340.20 333.50 415.25 266.40
230 58 500265 MAHSEAMLES MAHARASHTRA SEAMLESS LTD. 344.75 335.10 512.50 335.10
231 191 519552 HERITGFOOD Heritage Foods Limited 347.75 327.65 570.00 289.90
232 442 540678 COCHINSHIP Cochin Shipyard Ltd 350.00 337.55 491.15 320.15
233 410 539551 NH Narayana Hrudayalaya Ltd 351.95 334.90 389.00 181.35
234 259 532300 WOCKPHARMA WOCKHARDT LTD. 352.95 324.75 470.50 230.00
235 374 533274 PRESTIGE PRESTIGE ESTATES PROJECTS LTD. 356.40 342.00 426.15 193.10
236 200 523367 DCMSHRIRAM DCM Shriram Limited 356.70 340.10 637.00 310.75
237 424 540047 DBL Dilip Buildcon Ltd 360.05 344.05 733.85 317.00
238 346 532921 ADANIPORTS ADANI PORTS AND SPECIAL ECONOMIC ZONE LTD. 367.95 358.50 430.00 316.00
239 221 530001 GUJALKALI GUJARAT ALKALIES & CHEMICALS LTD. 370.85 357.00 595.80 351.75
240 313 532720 M&MFIN MAHINDRA & MAHINDRA FINANCIAL SERVICES LTD. 372.75 364.85 452.65 285.15
241 36 500144 FINCABLES FINOLEX CABLES LTD. 374.65 360.30 506.75 334.95
242 322 532784 SOBHA Sobha Limited 375.35 363.00 587.95 363.00
243 425 540064 FRETAIL Future Retail Ltd 377.40 352.45 489.25 323.25
244 198 522287 KALPATPOWR KALPATARU POWER TRANSMISSION LTD. 379.00 368.00 553.50 327.40
245 293 532539 MINDAIND MINDA INDUSTRIES LTD.-$ 379.20 371.50 425.85 263.10
246 261 532313 MAHLIFE MAHINDRA LIFESPACE DEVELOPERS LTD. 380.20 367.65 454.15 351.90
247 55 500253 LICHSGFIN LIC HOUSING FINANCE LTD. 382.45 354.50 586.80 354.00
248 300 532638 SHOPERSTOP SHOPPERS STOP LTD. 384.60 379.20 519.00 338.60
249 119 500800 TATAGLOBAL Tata Global Beverages Limited 386.25 373.40 407.95 181.50
250 416 539874 UJJIVAN Ujjivan Financial Services Ltd 388.60 375.00 415.40 251.95
251 172 512179 SUNTECK SUNTECK REALTY LTD. 392.80 381.40 532.00 320.00
252 238 532129 HEXAWARE HEXAWARE TECHNOLOGIES LTD. 393.60 366.50 439.00 320.20
253 451 540767 NAM-INDIA Nippon Life India Asset Management Ltd 394.50 366.00 411.85 149.30
254 396 536507 FLFL Future Lifestyle Fashions Ltd 404.00 388.45 502.00 380.75
255 464 541578 VARROC Varroc Engineering Ltd 408.15 385.00 666.35 380.05
256 215 524715 SUNPHARMA SUN PHARMACEUTICAL INDUSTRIES LTD. 410.75 399.10 484.10 350.40
257 452 540768 MAHLOG Mahindra Logistics Ltd 414.15 398.60 574.80 325.00
258 430 540173 PNBHOUSING PNB Housing Finance Ltd 415.00 404.00 976.45 371.90
259 5 500031 BAJAJELEC BAJAJ ELECTRICALS LTD.-$ 419.00 391.55 573.64 298.95
260 39 500164 GODREJIND GODREJ INDUSTRIES LTD. 420.15 403.50 553.50 377.00
261 280 532497 RADICO RADICO KHAITAN LTD. 422.85 401.30 437.00 260.05
262 91 500470 TATASTEEL TATA STEEL LTD. 434.75 421.35 560.35 320.30
263 433 540222 LAURUSLABS Laurus Labs Ltd 435.90 422.35 460.00 298.00
264 18 500087 CIPLA CIPLA LTD. 437.50 428.50 585.50 389.55
265 456 541153 BANDHANBNK Bandhan Bank Ltd 437.80 420.50 650.00 420.50
266 264 532343 TVSMOTOR TVS MOTOR COMPANY LTD. 443.20 424.50 524.80 340.30
267 244 532175 CYIENT Cyient Limited 446.40 430.15 692.30 380.00
268 82 500403 SUNDRMFAST SUNDRAM FASTENERS LTD. 451.60 445.45 593.45 400.00
269 439 540596 ERIS Eris Lifesciences Ltd 454.50 430.50 661.95 357.80
270 157 507880 VIPIND V.I.P.INDUSTRIES LTD.-$ 467.40 448.75 519.90 342.00
271 143 505533 WESTLIFE WESTLIFE DEVELOPMENT LTD. 469.25 448.00 499.90 257.20
272 102 500547 BPCL BHARAT PETROLEUM CORPORATION LTD. 472.35 456.50 549.70 308.55
273 428 540133 ICICIPRULI ICICI Prudential Life Insurance Company Ltd 475.00 466.00 537.50 299.75
274 310 532706 INOXLEISUR INOX LEISURE LTD. 476.40 459.75 486.00 249.25
275 286 532514 IGL INDRAPRASTHA GAS LTD. 479.80 462.00 534.40 277.00
276 152 506655 SUDARSCHEM SUDARSHAN CHEMICAL INDUSTRIES LTD. 480.50 456.75 505.95 302.00
277 315 532733 SUNTV SUN TV NETWORK LTD. 480.90 464.55 649.40 389.40
278 97 500493 BHARATFORG BHARAT FORGE LTD. 484.85 473.20 547.90 378.00
279 150 506401 DEEPAKNI DEEPAK NITRITE LTD.-$ 491.55 432.00 491.55 212.45
280 450 540762 TIINDIA Tube Investments of India Ltd 498.50 481.05 549.00 325.00
281 458 541179 ISEC ICICI Securities Ltd 498.55 471.20 498.60 191.00
282 435 540425 SHANKARA Shankara Building Products Ltd 502.00 488.05 583.00 240.00
283 290 532531 STAR Strides Pharma Science Ltd 502.40 483.20 547.35 288.00
284 216 524804 AUROPHARMA AUROBINDO PHARMA LTD. 502.80 482.50 838.00 389.70
285 60 500271 MFSL Max Financial Services Ltd 505.50 486.65 567.90 370.00
286 392 535648 JUSTDIAL JUST DIAL LTD. 505.85 480.50 824.85 464.00
287 20 500096 DABUR DABUR INDIA LTD. 506.85 496.20 523.20 357.10
288 166 511196 CANFINHOME CAN FIN HOMES LTD. 512.70 504.35 519.00 240.40
289 224 530019 JUBILANT JUBILANT LIFE SCIENCES LIMITED 513.80 489.15 898.00 392.30
290 387 534804 CARERATING CARE Ratings Ltd 514.65 485.05 1019.00 444.50
291 40 500165 KANSAINER KANSAI NEROLAC PAINTS LTD. 514.80 498.85 573.00 372.00
292 373 533273 OBEROIRLTY OBEROI REALTY LTD. 519.50 500.50 641.70 451.00
293 100 500520 M&M MAHINDRA & MAHINDRA LTD. 524.85 514.30 703.80 502.70
294 190 517569 KEI KEI INDUSTRIES LTD. 532.30 528.50 614.70 306.00
295 94 500480 CUMMINSIND CUMMINS INDIA LTD. 536.45 523.65 799.50 498.05
296 50 500233 KAJARIACER KAJARIA CERAMICS LTD. 539.00 525.55 648.85 442.75
297 447 540743 GODREJAGRO Godrej Agrovet Ltd 540.65 523.70 597.95 421.70
298 140 504973 CHOLAHLDNG Cholamandalam Financial Holdings Ltd 542.00 504.60 568.20 421.50
299 243 532174 ICICIBANK ICICI BANK LTD. 543.15 536.15 552.40 337.20
300 231 531344 CONCOR CONTAINER CORPORATION OF INDIA LTD. 550.05 532.10 665.05 460.00
301 129 500940 FINOLEXIND FINOLEX INDUSTRIES LTD. 559.10 548.00 635.00 440.00
302 154 506943 JBCHEPHARM J.B.CHEMICALS & PHARMACEUTICALS LTD. 561.45 516.45 599.00 307.00
303 465 541700 TCNSBRANDS TCNS Clothing Co. Ltd 564.90 555.20 865.20 547.20
304 454 540777 HDFCLIFE HDFC Life Insurance Company Ltd 565.10 556.10 646.40 346.15
305 271 532454 BHARTIARTL BHARTI AIRTEL LTD. 568.60 537.65 568.60 275.58
306 159 509480 BERGEPAINT BERGER PAINTS INDIA LTD. 580.05 570.25 597.45 284.40
307 9 500040 CENTURYTEX CENTURY TEXTILES & INDUSTRIES LTD. 586.00 568.00 657.00 322.85
308 71 500330 RAYMOND RAYMOND LTD. 586.50 570.40 868.80 533.10
309 420 539978 QUESS Quess Corp Ltd 589.05 572.95 819.85 386.85
310 171 512070 UPL UPL Limited 590.30 574.10 709.25 498.05
311 441 540673 SIS Security and Intelligence Services (India) Ltd 592.00 544.00 592.00 351.20
312 179 513434 TATAMETALI TATA METALIKS LTD. 595.60 571.05 704.10 480.85
313 174 512573 AVANTI AVANTI FEEDS LTD.-$ 598.15 562.20 769.90 253.00
314 187 517354 HAVELLS HAVELLS INDIA LTD. 603.45 589.25 806.90 586.00
315 256 532281 HCLTECH HCL TECHNOLOGIES LTD. 615.65 605.00 624.00 497.00
316 349 532927 ECLERX ECLERX SERVICES LTD. 623.20 598.80 1179.00 381.05
317 149 506395 COROMANDEL COROMANDEL INTERNATIONAL LTD. 627.00 604.40 643.95 336.50
318 235 531531 HATSUN HATSUN AGRO PRODUCT LTD. 629.00 611.90 774.90 547.30
319 269 532424 GODREJCP GODREJ CONSUMER PRODUCTS LTD. 634.80 613.25 771.75 577.00
320 415 539871 THYROCARE Thyrocare Technologies Ltd 635.00 612.00 689.45 406.65
321 342 532889 KPRMILL K.P.R. Mill Limited 636.30 622.30 714.20 521.05
322 146 506076 GRINDWELL GRINDWELL NORTON LTD.-$ 648.00 615.10 699.00 510.00
323 381 533573 APLLTD ALEMBIC PHARMACEUTICALS LTD. 649.65 637.45 666.00 435.10
324 217 524816 NATCOPHARM NATCO PHARMA LTD. 669.75 635.00 737.80 482.00
325 15 500084 CESC CESC LTD. 689.00 673.30 854.90 642.10
326 105 500575 VOLTAS VOLTAS LTD. 700.70 684.65 731.05 516.25
327 56 500257 LUPIN LUPIN LTD. 711.40 694.20 882.15 646.20
328 367 533179 PERSISTENT PERSISTENT SYSTEMS LTD. 713.10 697.50 739.90 472.25
329 457 541154 HAL Hindustan Aeronautics Ltd 723.80 699.65 896.35 603.25
330 233 531500 RAJESHEXPO RAJESH EXPORTS LTD. 726.00 706.00 802.00 555.00
331 66 500300 GRASIM GRASIM INDUSTRIES LTD. 736.00 715.10 958.55 635.60
332 251 532215 AXISBANK AXIS BANK LTD. 737.60 724.65 826.55 622.60
333 142 505355 NESCO NESCO LTD. 745.00 713.30 816.90 420.00
334 73 500335 BIRLACORPN BIRLA CORPORATION LTD. 749.00 738.75 807.60 440.50
335 397 538567 GULFOILLUB Gulf Oil Lubricants India Ltd 755.45 742.65 909.00 674.90
336 117 500770 TATACHEM TATA CHEMICALS LTD. 756.55 743.20 779.30 543.60
337 53 500251 TRENT TRENT LTD. 764.00 716.00 782.55 320.00
338 205 523457 LINDEINDIA Linde India Limited 779.95 755.00 791.30 420.00
339 1 500008 AMARAJABAT AMARA RAJA BATTERIES LTD. 780.00 757.15 814.00 572.60
340 260 532309 GEPIL GE Power India Ltd 781.20 760.05 933.00 657.00
341 344 532892 MOTILALOFS MOTILAL OSWAL FINANCIAL SERVICES LTD. 785.40 750.10 903.50 480.40
342 57 500260 RAMCOCEM The Ramco Cements Limited 790.00 777.00 883.30 593.20
343 47 500209 INFY INFOSYS LTD. 798.90 783.30 847.40 615.00
344 431 540180 VBL Varun Beverages Ltd 820.00 780.65 869.95 510.26
345 225 530517 RELAXO RELAXO FOOTWEARS LTD.-$ 826.70 810.90 830.15 343.50
346 317 532755 TECHM TECH MAHINDRA LTD. 840.00 827.45 846.00 607.90
347 14 500067 BLUESTARCO BLUE STAR LTD. 848.00 818.00 887.00 560.30
348 136 503100 PHOENIXLTD The Phoenix Mills Ltd 858.00 847.05 912.65 564.30
349 10 500042 BASF BASF INDIA LTD. 866.90 834.00 1495.00 834.00
350 98 500495 ESCORTS ESCORTS LTD. 896.50 872.65 896.50 423.30
351 377 533398 MUTHOOTFIN MUTHOOT FINANCE LTD. 898.00 846.40 898.00 515.00
352 12 500048 BEML BEML LTD. 915.00 871.95 1108.20 644.00
353 446 540719 SBILIFE SBI Life Insurance Company Ltd 921.00 907.10 1030.00 510.00
354 218 526299 MPHASIS MPHASIS LTD. 921.00 886.65 1059.50 828.15
355 131 501301 TATAINVEST TATA INVESTMENT CORPORATION LTD. 938.00 916.70 1025.00 745.05
356 85 500411 THERMAX THERMAX LTD. 981.10 949.90 1180.00 928.70
357 211 524200 VINATIORGA VINATI ORGANICS LTD.-$ 985.50 960.00 1255.50 695.00
358 83 500408 TATAELXSI TATA ELXSI LTD. 991.65 936.00 1098.75 593.00
359 328 532819 MINDTREE MINDTREE LTD. 1000.00 982.10 1000.00 652.50
360 212 524208 AARTIIND AARTI INDUSTRIES LTD. 1009.50 956.80 1042.75 637.76
361 162 509631 HEG HEG LTD. 1010.15 966.50 2302.20 833.75
362 135 502986 VTL VARDHMAN TEXTILES LTD. 1032.00 1021.85 1154.00 849.20
363 196 522113 TIMKEN TIMKEN INDIA LTD. 1048.55 1000.50 1070.00 508.70
364 429 540153 ENDURANCE Endurance Technologies Ltd 1057.55 1029.50 1380.00 743.05
365 128 500878 CEATLTD CEAT LTD. 1063.00 998.15 1178.00 731.00
366 132 501425 BBTC BOMBAY BURMAH TRADING CORP.LTD. 1130.90 1107.00 1384.00 740.25
367 363 533150 GODREJPROP Godrej Properties Ltd 1135.40 1097.80 1188.00 687.00
368 440 540611 AUBANK AU Small Finance Bank Ltd 1158.05 1131.50 1177.95 542.75
369 248 532187 INDUSINDBK INDUSIND BANK LTD. 1174.05 1109.20 1835.00 1109.20
370 419 539957 MGL Mahanagar Gas Ltd 1174.60 1118.00 1246.80 754.70
371 314 532725 SOLARINDS SOLAR INDUSTRIES INDIA LTD. 1190.00 1138.35 1350.00 923.60
372 331 532830 ASTRAL ASTRAL POLY TECHNIK LTD. 1192.10 1163.25 1265.20 848.00
373 42 500180 HDFCBANK HDFC Bank Ltd 1218.00 1204.00 1304.10 1035.13
374 134 502355 BALKRISIND BALKRISHNA INDUSTRIES LTD.-$ 1273.45 1228.95 1284.00 682.65
375 6 500033 FORCEMOT FORCE MOTORS LTD.-$ 1280.00 1231.60 1869.00 951.00
376 167 511218 SRTRANSFIN SHRIRAM TRANSPORT FINANCE CO.LTD. 1285.65 1246.20 1299.00 909.25
377 283 532504 NAVINFLUOR Navin Fluorine International Limited-$ 1288.50 1195.00 1288.50 570.20
378 99 500510 LT LARSEN & TOUBRO LTD. 1289.65 1266.65 1606.70 1236.00
379 275 532478 UBL UNITED BREWERIES LTD.-$ 1294.00 1256.80 1483.55 1184.85
380 384 534091 MCX MULTI COMMODITY EXCHANGE OF INDIA LTD. 1305.00 1260.00 1442.00 643.50
381 30 500114 TITAN Titan Company Limited 1318.40 1302.00 1389.85 998.70
382 38 500163 GODFRYPHLP GODFREY PHILLIPS INDIA LTD. 1322.40 1292.20 1480.40 675.30
383 122 500830 COLPAL COLGATE-PALMOLIVE (INDIA) LTD. 1332.75 1306.80 1641.00 1104.00
384 445 540716 ICICIGI ICICI Lombard General Insurance Company Ltd 1343.95 1327.00 1439.90 895.25
385 108 500660 GLAXO GLAXOSMITHKLINE PHARMACEUTICALS LTD. 1349.40 1318.00 1745.00 1131.05
386 263 532331 AJANTPHARM AJANTA PHARMA LTD. 1356.00 1276.00 1483.40 840.00
387 188 517385 SYMPHONY Symphony Limited 1360.00 1336.50 1575.00 1070.00
388 214 524494 IPCALAB IPCA LABORATORIES LTD. 1380.30 1307.00 1507.95 778.90
389 103 500550 SIEMENS SIEMENS LTD. 1399.55 1363.00 1716.55 933.70
390 163 509930 SUPREMEIND SUPREME INDUSTRIES LTD. 1400.00 1385.00 1412.00 950.20
391 301 532644 JKCEMENT J.K.CEMENT LTD. 1420.25 1380.00 1465.00 690.35
392 84 500410 ACC ACC LTD. 1427.00 1403.25 1768.40 1325.00
393 281 532498 SHRIRAMCIT SHRIRAM CITY UNION FINANCE LTD. 1453.80 1407.70 1900.00 1221.55
394 405 539448 INDIGO InterGlobe Aviation Ltd 1479.00 1428.00 1911.00 1078.85
395 70 500325 RELIANCE RELIANCE INDUSTRIES LTD. 1479.00 1458.00 1617.80 1095.65
396 199 523261 VENKYS VENKY'S (INDIA) LTD. 1483.00 1369.40 2407.00 1100.00
397 230 531335 ZYDUSWELL ZYDUS WELLNESS LTD.-$ 1485.45 1461.00 1858.85 1217.00
398 201 523385 NILKAMAL NILKAMAL LTD. 1525.00 1456.65 1544.15 890.45
399 67 500302 PEL PIRAMAL ENTERPRISES LTD. 1533.00 1473.95 2728.85 1270.75
400 208 523642 PIIND PI Industries Ltd 1540.05 1500.45 1626.00 864.00
401 72 500331 PIDILITIND PIDILITE INDUSTRIES LTD. 1590.30 1569.30 1609.00 1048.85
402 19 500092 CRISIL CRISIL LTD. 1595.70 1541.00 2070.00 1135.45
403 408 539524 LALPATHLAB Dr. Lal PathLabs Ltd 1660.05 1580.05 1845.90 950.10
404 432 540203 SFL Sheela Foam Ltd 1662.00 1615.35 1770.00 1084.00
405 409 539542 LUXIND Lux Industries Ltd 1680.00 1571.35 1680.00 983.50
406 52 500247 KOTAKBANK KOTAK MAHINDRA BANK LTD. 1699.00 1678.80 1734.35 1209.50
407 427 540115 LTTS L&T Technology Services Ltd 1727.00 1666.00 1817.75 1395.60
408 158 508869 APOLLOHOSP APOLLO HOSPITALS ENTERPRISE LTD. 1783.30 1706.65 1783.30 1083.00
409 11 500043 BATAINDIA BATA INDIA LTD. 1817.80 1785.00 1897.00 1251.60
410 306 532683 AIAENG AIA ENGINEERING LTD. 1819.85 1771.55 2026.00 1484.20
411 295 532541 NIITTECH NIIT TECHNOLOGIES LTD. 1853.75 1808.00 2057.00 1179.90
412 365 533155 JUBLFOOD Jubilant FoodWorks Ltd 1858.40 1812.70 1973.05 1078.05
413 120 500820 ASIANPAINT ASIAN PAINTS LTD. 1884.80 1862.00 1915.65 1291.45
414 467 541988 AAVAS AAVAS Financiers Ltd 1945.35 1873.05 2078.30 868.25
415 92 500472 SKFINDIA SKF India Ltd 1960.90 1943.70 2313.00 1742.80
416 422 540005 LTI Larsen & Toubro Infotech Ltd 2025.50 1936.80 2049.40 1436.65
417 383 533758 APLAPOLLO APL APOLLO TUBES LTD. 2036.00 1990.00 2216.95 1079.00
418 307 532689 PVR PVR LTD. 2093.90 2054.00 2097.90 1345.80
419 86 500420 TORNTPHARM TORRENT PHARMACEUTICALS LTD. 2156.60 2114.05 2156.60 1453.00
420 279 532488 DIVISLAB DIVI'S LABORATORIES LTD. 2180.40 2143.65 2189.00 1466.95
421 294 532540 TCS TATA CONSULTANCY SERVICES LTD. 2221.35 2186.75 2296.00 1882.00
422 114 500696 HINDUNILVR HINDUSTAN UNILEVER LTD. 2260.00 2222.15 2297.35 1649.70
423 43 500182 HEROMOTOCO HERO MOTOCORP LTD. 2280.20 2225.00 3021.15 2225.00
424 390 534976 VMART V-MART RETAIL LTD. 2299.00 2196.45 2867.00 1604.00
425 51 500238 WHIRLPOOL WHIRLPOOL OF INDIA LTD. 2309.75 2212.75 2570.00 1292.40
426 2 500010 HDFC HOUSING DEVELOPMENT FINANCE CORP.LTD. 2346.00 2304.25 2499.65 1821.55
427 434 540376 DMART Avenue Supermarts Ltd 2386.00 2307.35 2559.00 1225.95
428 115 500710 AKZOINDIA Akzo Nobel India Limited 2407.95 2317.00 2500.00 1600.00
429 270 532443 CERA CERA SANITARYWARE LTD. 2414.15 2370.30 3180.00 2151.00
430 412 539658 TEAMLEASE TeamLease Services Ltd 2498.35 2335.35 3201.40 2261.00
431 407 539523 ALKEM Alkem Laboratories Ltd 2640.00 2505.00 2698.50 1660.35
432 153 506820 ASTRAZEN ASTRAZENECA PHARMA INDIA LTD. 2796.20 2667.60 2940.45 1635.30
433 273 532466 OFSS ORACLE FINANCIAL SERVICES SOFTWARE LTD. 2892.55 2856.00 3649.00 2482.00
434 220 526612 BLUEDART BLUE DART EXPRESS LTD. 2910.00 2850.00 3650.00 2019.00
435 320 532777 NAUKRI INFO EDGE (INDIA) LTD. 2910.75 2751.25 3125.00 1600.05
436 203 523398 JCHAC Johnson Controls-Hitachi Air Conditioning Indi... 2945.55 2751.30 2945.70 1475.00
437 121 500825 BRITANNIA BRITANNIA INDUSTRIES LTD. 3075.35 3022.10 3443.90 2302.00
438 355 532977 BAJAJ-AUTO BAJAJ AUTO LTD. 3090.00 3036.00 3315.00 2400.00
439 466 541729 HDFCAMC HDFC Asset Management Company Ltd 3246.75 3183.55 3844.00 1302.00
440 32 500124 DRREDDY DR.REDDY'S LABORATORIES LTD. 3281.90 3235.00 3341.45 2352.00
441 54 500252 LAXMIMACH LAKSHMI MACHINE WORKS LTD. 3295.00 3214.70 6431.40 3133.90
442 96 500490 BAJAJHLDNG BAJAJ HOLDINGS & INVESTMENT LTD. 3715.00 3683.35 3949.35 3001.00
443 138 503806 SRF SRF LTD. 4170.25 4125.00 4230.00 2161.50
444 112 500680 PFIZER PFIZER LTD. 4172.40 4020.00 4649.40 2797.50
445 148 506285 BAYERCROP BAYER CROPSCIENCE LTD. 4263.55 4216.10 4660.00 2952.00
446 34 500126 PGHL Procter & Gamble Health Ltd 4287.00 4102.00 5120.80 2866.25
447 164 509966 VSTIND VST INDUSTRIES LTD. 4375.00 4300.75 4856.45 3166.80
448 292 532538 ULTRACEMCO ULTRATECH CEMENT LTD. 4486.40 4371.95 4903.90 3385.00
449 145 505790 SCHAEFFLER Schaeffler India Ltd 4582.85 4370.00 5699.95 3841.00
450 59 500266 MAHSCOOTER MAHARASHTRA SCOOTERS LTD. 4775.00 4650.00 4948.00 3034.05
451 7 500034 BAJFINANCE Bajaj Finance Limited 4777.05 4704.00 4815.00 2513.00
452 4 500027 ATUL ATUL LTD. 5017.15 4920.00 5114.00 3267.70
453 189 517506 TTKPRESTIG TTK PRESTIGE LTD. 5944.00 5833.90 7738.57 5046.65
454 156 507815 GILLETTE GILLETTE INDIA LTD. 6125.00 5851.20 8200.00 5851.20
455 357 533023 WABCOINDIA WABCO INDIA LTD. 6853.75 6790.50 7082.65 5798.40
456 282 532500 MARUTI MARUTI SUZUKI INDIA LTD. 6934.50 6701.00 7755.00 5447.00
457 110 500674 SANOFI Sanofi India Ltd 7205.00 6982.95 7472.35 5300.00
458 356 532978 BAJAJFINSV BAJAJ FINSERV LTD. 9559.40 9438.05 10297.00 5851.15
459 111 500676 GSKCONS GLAXOSMITHKLINE CONSUMER HEALTHCARE LTD. 9729.95 9581.00 9876.70 6868.00
460 89 500459 PGHH PROCTER & GAMBLE HYGIENE & HEALTH CARE LTD. 11323.15 11220.00 12699.90 9799.85
461 101 500530 BOSCHLTD BOSCH LTD. 14864.35 14475.50 19422.55 12698.80
462 95 500488 ABBOTINDIA ABBOTT INDIA LTD. 15650.00 14550.00 15650.00 7150.00
463 118 500790 NESTLEIND NESTLE INDIA LTD. 16565.00 16375.00 16753.45 10028.10
464 141 505200 EICHERMOT EICHER MOTORS LTD. 18791.80 18360.75 23427.75 15196.95
465 202 523395 3MINDIA 3M INDIA LTD. 22189.10 22007.35 25361.10 18200.00
466 330 532827 PAGEIND PAGE INDUSTRIES LTD. 22900.00 22240.00 26891.00 17140.70
467 79 500387 SHREECEM SHREE CEMENT LTD. 24009.10 23304.55 25341.20 15055.30
468 185 517174 HONAUT HONEYWELL AUTOMATION INDIA LTD. 36550.00 35200.05 39499.50 21305.05
469 62 500290 MRF MRF LTD. 71307.55 69550.10 73500.00 51850.00
In [89]:
for id in df['Security Id']:
    try:
        data = quandl.get(["NSE/{}".format(id)], start_date="2010-02-18", end_date="2020-02-18")
        print(id)
        a=data['NSE/{} - Open'.format(id)]
        plt.figure(figsize=(20,5))
        plt.title(id)
        plt.plot(a)
        plt.show()
    except Exception as e:
        pass
plt.show()
JPASSOCIAT
RPOWER
SUZLON
IDEA
TRIDENT
IFCI
JISLJALEQS
RELCAPITAL
SREINFRA
SOUTHBANK
IOB
DHFL
DISHTV
UCOBANK
ALBK
ANDHRABANK
CENTRALBK
HFCL
LAKSHVILAS
PCJEWELLER
MMTC
J&KBANK
CENTRUM
CORPBANK
FCONSUMER
NHPC
RELINFRA
SYNDIBANK
HATHWAY
GMRINFRA
SJVN
TV18BRDCST
NBCC
HUDCO
IDFC
IDBI
BHEL
HINDCOPPER
YESBANK
INOXWIND
ARVIND
IDFCFIRSTB
NATIONALUM
MRPL
JAMNAAUTO
SAIL
NCC
ORIENTBANK
RCF
FSL
WELSPUNIND
VAKRANGEE
UNIONBANK
MAGMA
PTC
HSCL
TATAPOWER
PNB
TIMETECHNO
NLCINDIA
SCI
ADANIPOWER
INFIBEAM
ITDCEM
MEGH
GMDCLTD
LEMONTREE
BANKINDIA
PRSMJOHNSN
JKTYRE
JSWENERGY
TATAMTRDVR
EVEREADY
TEJASNET
JAGRAN*
NBVENTURES
INDIACEM
GSFC
JSLHISAR
KTKBANK
GPPL
ORIENTCEM
ASHOKLEY
INDIANB
BANKBARODA
ITI
BOMDYEING
ENGINERSIN
BEL
FEDERALBNK
MAXINDIA
STARCEMENT
SPICEJET
IBREALEST
NOCIL
ABCAPITAL
EDELWEISS
TRITURBINE
JINDALSAW
BSOFT
DCAL*
DEEPAKFERT
JAICORPLTD
SADBHAV
ASHOKA
TAKE
ONGC
IBULISL
NMDC
IRB
HIMATSEIDE
PARAGMILK
RAIN
EQUITAS
NTPC
JMFINANCIL
STRTECH
IOC
SHK
REDINGTON
GAIL
GICHSGFIN
CHENNPETRO
L&TFH
MOTHERSUMI
DBCORP
PHILIPCARB
GDL
SWANENERGY
PFC
JYOTHYLAB
NIACL
INDHOTEL
OIL
EIHOTEL
RECLTD
INTELLECT
MOIL
BLISSGVS
VEDL
ZENSARTECH
GET&D
GREAVESCOT
CENTURYPLY
APOLLOTYRE
FORTIS
DELTACORP
CASTROLIND
ADVENZYMES
CHAMBLFERT
MAHINDCIE
SPARC
OMAXE
ADANIGAS
TATAMOTORS
TNPL
BALRAMCHIN
MANAPPURAM
ASTERDM
DCBBANK
COALINDIA
CANBK
GHCL*
GNFC
EXIDEIND
GRANULES
POWERGRID
ESSELPRO
HINDZINC
JINDALSTEL
HINDALCO
IEX
SUPRAJIT
BAJAJCON
ADANIGREEN
IIFL
HEIDELBERG
AMBUJACEM
VGUARD
ITC
PNCINFRA
WELCORP
WABAG
EIDPARRY
GICRE
DLF
CUB
UFLEX
MHRIL
ELGIEQUIP
HINDPETRO
RALLIS
INFRATEL
GSPL
WIPRO
FDC
ZEEL
CCL
ADANIENT
ASAHIINDIA
AEGISLOG
PETRONET
GRAPHITE
ORIENTELEC
CADILAHC
ABFRL
GESHIP
EMAMILTD
INDOSTAR
KNRCON
JSWSTEEL
GUJGAS
CROMPTON
MARICO
REPCOHOME
BIOCON
SYNGENE
RBLBANK
KRBL
IBULHSGFIN
GLENMARK
ADANITRANS
SBIN
RITES
TORNTPOWER
JKLAKSHMI
CHOLAFIN
KEC
SONATSOFTW
CARBORUNIV
MAHSEAMLES
HERITGFOOD
COCHINSHIP
NH
WOCKPHARMA
PRESTIGE
DCMSHRIRAM
DBL
ADANIPORTS
GUJALKALI
M&MFIN
FINCABLES
SOBHA
FRETAIL
KALPATPOWR
MINDAIND
MAHLIFE
LICHSGFIN
SHOPERSTOP
TATAGLOBAL
UJJIVAN
SUNTECK
HEXAWARE
NAM-INDIA
FLFL
VARROC
SUNPHARMA
MAHLOG
PNBHOUSING
BAJAJELEC
GODREJIND
RADICO
TATASTEEL
LAURUSLABS
CIPLA
BANDHANBNK
TVSMOTOR
CYIENT
SUNDRMFAST
ERIS
VIPIND
WESTLIFE
BPCL
ICICIPRULI
INOXLEISUR
IGL
SUDARSCHEM
SUNTV
BHARATFORG
DEEPAKNI
TIINDIA
ISEC
SHANKARA
STAR
AUROPHARMA
MFSL
JUSTDIAL
DABUR
CANFINHOME
JUBILANT
CARERATING
KANSAINER
OBEROIRLTY
M&M
KEI
CUMMINSIND
KAJARIACER
GODREJAGRO
CHOLAHLDNG
ICICIBANK
CONCOR
FINOLEXIND
JBCHEPHARM
TCNSBRANDS
HDFCLIFE
BHARTIARTL
BERGEPAINT
CENTURYTEX
RAYMOND
QUESS
UPL
SIS
TATAMETALI
AVANTI
HAVELLS
HCLTECH
ECLERX
COROMANDEL
HATSUN
GODREJCP
THYROCARE
KPRMILL
GRINDWELL
APLLTD
NATCOPHARM
CESC
VOLTAS
LUPIN
PERSISTENT
HAL
RAJESHEXPO
GRASIM
AXISBANK
NESCO
BIRLACORPN
GULFOILLUB
TATACHEM
TRENT
LINDEINDIA
AMARAJABAT
GEPIL
MOTILALOFS
RAMCOCEM
INFY
VBL
RELAXO
TECHM
BLUESTARCO
PHOENIXLTD
BASF
ESCORTS
MUTHOOTFIN
BEML
SBILIFE
MPHASIS
TATAINVEST
THERMAX
VINATIORGA
TATAELXSI
MINDTREE
AARTIIND
HEG
VTL
TIMKEN
ENDURANCE
CEATLTD
BBTC
GODREJPROP
AUBANK
INDUSINDBK
MGL
SOLARINDS
ASTRAL
HDFCBANK
BALKRISIND
FORCEMOT
SRTRANSFIN
NAVINFLUOR
LT
UBL
MCX
TITAN
GODFRYPHLP
COLPAL
ICICIGI
GLAXO
AJANTPHARM
SYMPHONY
IPCALAB
SIEMENS
SUPREMEIND
JKCEMENT
ACC
SHRIRAMCIT
INDIGO
RELIANCE
VENKYS
ZYDUSWELL
NILKAMAL
PEL
PIIND
PIDILITIND
CRISIL
LALPATHLAB
SFL
LUXIND
KOTAKBANK
LTTS
APOLLOHOSP
BATAINDIA
AIAENG
NIITTECH
JUBLFOOD
ASIANPAINT
AAVAS
SKFINDIA
LTI
APLAPOLLO
PVR
TORNTPHARM
DIVISLAB
TCS
HINDUNILVR
HEROMOTOCO
VMART
WHIRLPOOL
HDFC
DMART
AKZOINDIA
CERA
TEAMLEASE
ALKEM
ASTRAZEN
OFSS
BLUEDART
NAUKRI
JCHAC
BRITANNIA
BAJAJ-AUTO
HDFCAMC
DRREDDY
LAXMIMACH
BAJAJHLDNG
SRF
PFIZER
BAYERCROP
PGHL
VSTIND
ULTRACEMCO
SCHAEFFLER
MAHSCOOTER
BAJFINANCE
ATUL
TTKPRESTIG
GILLETTE
WABCOINDIA
MARUTI
SANOFI
BAJAJFINSV
GSKCONS
PGHH
BOSCHLTD
ABBOTINDIA
NESTLEIND
EICHERMOT
3MINDIA
PAGEIND
SHREECEM
HONAUT
MRF
In [ ]:
 
In [ ]: